﻿CREATE TABLE [dbo].[OrderLineItemDetails_Tbl] (
    [OrderLineItemDetailsID] INT            NOT NULL,
    [OrderDetailsID]         INT            NULL,
    [OrderLineItem]          INT            NULL,
    [GenSailTypeID]          INT            NULL,
    [FurlingUnitID]          INT            NULL,
    [SailNumberColourID]     INT            NULL,
    [Window]                 BIT            NULL,
    [WindowSize]             INT            NULL,
    [WindowV1]               INT            NULL,
    [WindowV2]               INT            NULL,
    [MGT]                    INT            NULL,
    [MGU]                    INT            NULL,
    [MGM]                    INT            NULL,
    [MGL]                    INT            NULL,
    [TackID]                 INT            NULL,
    [TackCutback]            INT            NULL,
    [TackCutUp]              INT            NULL,
    [ReefCutback]            INT            NULL,
    [BoltRopeTotalID]        INT            NULL,
    [MastSliderTypeID]       INT            NULL,
    [BattenSliderType]       NVARCHAR (50)  NULL,
    [Reef1Height]            INT            NULL,
    [Reef2Height]            INT            NULL,
    [Reef3Height]            INT            NULL,
    [ReffCircle]             BIT            NULL,
    [FootStyleID]            INT            NULL,
    [BoomSliderID]           INT            NULL,
    [FoilEndTack]            INT            NULL,
    [FoilEndTop]             INT            NULL,
    [HeightSailInput]        INT            NULL,
    [HanksID]                INT            NULL,
    [TotalFoilDiamID]        INT            NULL,
    [TackSystemID]           INT            NULL,
    [Notes]                  NVARCHAR (MAX) NULL,
    [TopFilmID]              INT            NULL,
    [BotFilmID]              INT            NULL,
    [1Reef]                  BIT            NULL,
    [2RReef]                 BIT            NULL,
    [2CReef]                 BIT            NULL,
    [3Reef]                  BIT            NULL,
    [Luff]                   INT            NULL,
    [Leech]                  INT            NULL,
    [Foot]                   INT            NULL,
    [IsLeech]                BIT            NULL,
    [SailLP]                 INT            NULL,
    [CutLuff]                INT            NULL,
    [CutLeech]               INT            NULL,
    [CutFoot]                INT            NULL,
    [CutLP]                  INT            NULL,
    [RuleLuff]               INT            NULL,
    [RuleLeech]              INT            NULL,
    [RuleFoot]               INT            NULL,
    [RuleLP]                 INT            NULL,
    [SailGirth78]            INT            NULL,
    [SailGirth34]            INT            NULL,
    [SailGirth12]            INT            NULL,
    [SailGirth14]            INT            NULL,
    [CutGirth78]             INT            NULL,
    [CutGirth34]             INT            NULL,
    [CutGirth12]             INT            NULL,
    [CutGirth14]             INT            NULL,
    [RuleGirth78]            INT            NULL,
    [RuleGirth34]            INT            NULL,
    [RuleGirth12]            INT            NULL,
    [RuleGirth14]            INT            NULL,
    [SailSMW]                INT            NULL,
    [SailSMG]                INT            NULL,
    [CutSMW]                 INT            NULL,
    [CutSMG]                 INT            NULL,
    [RuleSMW]                INT            NULL,
    [RuleSMG]                INT            NULL,
    [UVColour]               NVARCHAR (15)  NULL,
    [UVSide]                 NVARCHAR (15)  NULL,
    [InsigniaColourID]       INT            NULL,
    [TrimStripeColourID]     INT            NULL
);

